﻿CREATE TABLE [dbo].[TempArticles]
(
	[Id] int IDENTITY(1,1) NOT NULL, 
	[RangeReviewId] int NOT NULL,
	[CategoryId] smallint NULL,
	[Code] varchar(20) NOT NULL,
	[Name] varchar(200) NOT NULL,
	[EAN] varchar(50) NULL,
	[UOM] varchar(50) NULL,
	[Brand] varchar(255) NULL,
	[Manufacturer] varchar(255) NULL,
	[NotFoundCategory] varchar(100) NULL,
	[Size] [smallmoney] NULL,
	[Width] [smallmoney] NULL,
	[Height] [smallmoney] NULL,
	[Facings] [smallmoney] NULL,
	[Attribute1] [varchar](200) NULL,
	[Attribute2] [varchar](200) NULL,
	[Attribute3] [varchar](200) NULL,
	[Attribute4] [varchar](200) NULL,
	[Attribute5] [varchar](200) NULL,
	[TaxRate] [smallmoney] NULL,
	[Type] [varchar](100) NULL,
	[OrderUOM] [varchar](100) NULL,
	[OrderEAN] [varchar](100) NULL,
	[Pack] [varchar](100) NULL,
	[Vendor] [varchar](100) NULL,
	[Price] [money] NULL,	
	[Cost] [money] NULL,
	[NetPrice] [money] NULL,
	[CreatedDate] [Date] NULL
)
